Alternative Captions

When working with MS OLAP or SAP BW data models, you can use cube-defined properties as alternative captions for elements in the query. This is particularly useful when working with BW databases, as you can replace the column IDs with the property descriptions, helping you interpret your data easily. In this case, the visualization will display the property descriptions, rather than the column ID's.

How to Display Property Captions

Step 1

Add the required hierarchy to the drop zones. Right click on the hierarchy from the drop zone and go to ‘Change Caption’ in the chip’s context menu.

Step 2

Select the required property from the submenu. The captions in the query will be replaced by the given property captions.

Step 3

To revert to the default captions, go back to the ‘Change Caption’ sub-menu and click ‘Reset Caption'.